CSV Export

CData Virtuality Studio allows to export any source table, virtual view or the result of any query to a CSV file. This dialog contains all the necessary controls and configuration options to perform the export.

Options

There are a few configuration options:

• File name: destination CSV file.
• Include column headers: controls if the header (column names) are included in the CSV file or not.
• Export newline as \n: controls if the newline characters should be exported as \n or not.
• Encoding: desired encoding for the result CSV file. "UTF-8" encoding is recommended.
• Separator: value separator character.
• Quote character: character used to wrap (quote) all the values. Recommended if the values may contain new line characters, commas or other special characters.
• Source: is a preview of the SQL statement that is used to produce the source data.